c21acdfb992c79570072bad2280fc6cf19b7e57a,src/spade/storage/SQL.java,SQL,getNeighborVertexIds,#number#,603

Before Change


            try {
                dbConnection.commit();
                // TODO: Handle exception case when getVertexFromId returns null
                String query = "SELECT dstVertexHash FROM edge WHERE srcVertexHash = " + getVertexFromId(vertexId).hashCode();
                Statement statement = dbConnection.createStatement();
                ResultSet result = statement.executeQuery(query);
                while (result.next()) {

After Change


                dbConnection.commit();
                // TODO: Handle exception case when getVertexFromId returns null
                String query = "SELECT vertexId FROM vertex WHERE hash IN (SELECT dstVertexHash FROM edge WHERE " +
                        "srcVertexHash = " + getVertexFromId(vertexId).getAnnotation("hash") + ")";
                Statement statement = dbConnection.createStatement();
                ResultSet result = statement.executeQuery(query);
                while (result.next())